﻿CREATE TABLE [steve].[SiteUrl] (
    [SiteUrlId]            UNIQUEIDENTIFIER NOT NULL,
    [SiteName]             VARCHAR (50)     NOT NULL,
    [SystemName] varchar(50) null,
    [ExternalId]           VARCHAR (100)     NULL,
    [CreateDate]           DATETIME2(7)         NOT NULL,
	[CreateMembershipId]	uniqueidentifier null,
    [LatestRevisionNumber] INT              NOT NULL,
    [Url]                  VARCHAR (800)    NOT NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Current site url metadata', @level0type = N'SCHEMA', @level0name = N'steve', @level1type = N'TABLE', @level1name = N'SiteUrl';

